UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8N/nTV/Fwj4qTpF9egoCROG1nvH9eG94Kv39yWH03nU='
WHERE
key_id = '2c6d8c69f740360596f828fbd8dbfb74a8938a4d76da93783da7c9b6daa9567a'
AND (
token = '8N/nTV/Fwj4qTpF9egoCROG1nvH9eG94Kv39yWH03nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)