UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gN+m6luIfzQdVl3ifwvKEQeYZW/iurSX/JsU1T5b3DM='
WHERE
key_id = 'a9fce62277a8f5317c71714ac92065517910cb028359f842cdeae4a77c21b1df'
AND (
token = 'gN+m6luIfzQdVl3ifwvKEQeYZW/iurSX/JsU1T5b3DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)