UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J7UMj6ahIYcfqAAM0MwfAG3/a1VW190PwUCZ7AttDBA='
WHERE
key_id = '296925db978bd1b214020a3e90f1eda94d021ac9be4ebcd5a6fa9910a4f0d2e7'
AND (
token = 'J7UMj6ahIYcfqAAM0MwfAG3/a1VW190PwUCZ7AttDBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)