UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xy40wbLX4/yo/v8K9wmaMck0zxVUsM74HrI6KSReBVw='
WHERE
key_id = 'b4a25b198cd00411088a0165c5244f4dd19442b72f1c35e753a4dbe44aa399bf'
AND (
token = 'xy40wbLX4/yo/v8K9wmaMck0zxVUsM74HrI6KSReBVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)