UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYpP1lAhzuS5VVXg+72kO8zFyJB/voVw5SuEjzxzd6A='
WHERE
key_id = '6118e22784beba1b6481686083c8768f63aff8c648f98fbcd74050c587c43375'
AND (
token = 'hYpP1lAhzuS5VVXg+72kO8zFyJB/voVw5SuEjzxzd6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)