UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qON/TiwpifDY9lFT5yA9/2dr99qfuWDWVOWeQVR4tnU='
WHERE
key_id = 'f3507c127621a15c49b82523d465a13ad88793f6505a10471b7e81b75a11f22b'
AND (
token = 'qON/TiwpifDY9lFT5yA9/2dr99qfuWDWVOWeQVR4tnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)