UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFhTROGlG88xiE9iYMMHS+F2hn07rDbprhoPmG3pscU='
WHERE
key_id = '53f1fe7ec65a268062291440fa84228ff1afa0a2a122b237a446d5452ab187ab'
AND (
token = 'XFhTROGlG88xiE9iYMMHS+F2hn07rDbprhoPmG3pscU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)