UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JBlbKIIMiaqO0jD40vLVjHBPmUA6y9HkH12+YVNbH0c='
WHERE
key_id = 'b01b79de089282e5d7ae79fb7980e7a6b1d63529e13fac7eac211113fb996e2e'
AND (
token = 'JBlbKIIMiaqO0jD40vLVjHBPmUA6y9HkH12+YVNbH0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)