UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zVYLyXs6ceWISrRev3rJx3gHjvXWqjD0V9un43C8/3k='
WHERE
key_id = 'bfc2fe8e4e63989c1959bdf27a52ca6e675adad06f79bc839ab33f1f43ef5797'
AND (
token = 'zVYLyXs6ceWISrRev3rJx3gHjvXWqjD0V9un43C8/3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)