UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qXqUwxGYvXhb1Z/5JMz1ovrYU1/WY/4lufwxtSY5XuI=' 
WHERE 
  key_id = '65638975beb868c645de2890c6e8fcf722f6e9aacbdbf5a6d48e57d11c7b4474' 
  AND (
    token = 'qXqUwxGYvXhb1Z/5JMz1ovrYU1/WY/4lufwxtSY5XuI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024