UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YqQdkudXF+bsv8GNTixmu6o64VbvOY7bedaCVHKVsbM='
WHERE
key_id = 'c59ed58ef7fcdb0511ce5932d92f993be74931a4aa7f65ff95a431d8867de333'
AND (
token = 'YqQdkudXF+bsv8GNTixmu6o64VbvOY7bedaCVHKVsbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)