UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zO7KNbZKisj/QZqy36hnMEsZmYRDaP2cyrjzWrzKano='
WHERE
key_id = '0d19c667cbe9b567b1e210da0addd7f709f331408799f65ed8525c47c571fa26'
AND (
token = 'zO7KNbZKisj/QZqy36hnMEsZmYRDaP2cyrjzWrzKano='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)