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