UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdNJzs6LQu/ZWqWFRlbBEXnl3TworiLQLLWAJvQqUjk='
WHERE
key_id = 'bae4e99f6653cb353c36168c2e0863654a95b49458a9f560cbbe4ede350b3b7d'
AND (
token = 'xdNJzs6LQu/ZWqWFRlbBEXnl3TworiLQLLWAJvQqUjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)