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