UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ofYzvm9yZfEZSC9bNqgNoSFqPJDez0W7VNJPF2rHTA='
WHERE
key_id = '2187af0e605f547f960e353592cfb4180f91e436f1ec1fed418d0cad379f04d0'
AND (
token = '4ofYzvm9yZfEZSC9bNqgNoSFqPJDez0W7VNJPF2rHTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)