UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XaR1g2fzFZhT6SneAJCfw0v3akk2srK7hMFdgFi6nRA='
WHERE
key_id = '23baf580c5a8bc41d1d19ac0dda4fcfb7009e2d73945108365ae4c02433c2c6b'
AND (
token = 'XaR1g2fzFZhT6SneAJCfw0v3akk2srK7hMFdgFi6nRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)