UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vyi3RINyn7m+NbagMq31jIIDdPSnmKI+HB6NKDK0N7c='
WHERE
key_id = '947253e953a079ddfc54bbbd36d74b8c560ff3d3fd984c313a0403aeab374587'
AND (
token = 'vyi3RINyn7m+NbagMq31jIIDdPSnmKI+HB6NKDK0N7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)