UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tvWJ7VT22VurdaVW0/su+haeo3wXU0iGS/NOVqYImI='
WHERE
key_id = 'd566327ec9c175c940fbb0df42a322ffcf9bd87fb6a5be08a822bf2422ee0efb'
AND (
token = '7tvWJ7VT22VurdaVW0/su+haeo3wXU0iGS/NOVqYImI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)