UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aR7D92CS+YkrBE0eoEM6YyfEEVch/p8KFxLG4LiZ90='
WHERE
key_id = '9801fc3de5a53302e27c767d15eee68fffb292ffee92a6a9bf1c33864a0b3a16'
AND (
token = '+aR7D92CS+YkrBE0eoEM6YyfEEVch/p8KFxLG4LiZ90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)