UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhWpUp9NfBAbz2iKwIzQN6BaKaUxb4zupMLRpyk07Ec='
WHERE
key_id = 'e60217e7dca9652920bb4fbeadfc15b727d7c53082faf7bc2979bdd8a4d5180b'
AND (
token = 'XhWpUp9NfBAbz2iKwIzQN6BaKaUxb4zupMLRpyk07Ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)