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