UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ldYmMW4mzFtnOamEsZ0POqkolJSIhCFMz/dljXo42Fc='
WHERE
key_id = '5865cfcb0e9b96b13bc947c680ac7bc4b12c976d33823770ba553f59e0b92d59'
AND (
token = 'ldYmMW4mzFtnOamEsZ0POqkolJSIhCFMz/dljXo42Fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)