UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9i7+P+VNCoSeasDMKEy9cgNbMMwa7y9lZpuknoKYZNY='
WHERE
key_id = '578c785f59a225433d177b0aeee2d99c1ca792f5157e4791339b59ed539332ad'
AND (
token = '9i7+P+VNCoSeasDMKEy9cgNbMMwa7y9lZpuknoKYZNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)