UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvJF76W5YeXKPflFRnGstVqKsyLEd8P3ZsXGdKOSg78='
WHERE
key_id = 'cdae5ac2e8b575ea9aca25a6fd06fe9f1e31484f6ec1e14643e3e56c27092c11'
AND (
token = 'qvJF76W5YeXKPflFRnGstVqKsyLEd8P3ZsXGdKOSg78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)