UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ozViEQ2N9pwlXB9LjG9bXOyjN8sHi7W49qFUfVdV930=' 
WHERE 
  key_id = '3526d8da52c7636039faf52be3fb7a64b7bb34d5c9c93e57cdf64457ed5b15a9' 
  AND (
    token = 'ozViEQ2N9pwlXB9LjG9bXOyjN8sHi7W49qFUfVdV930=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032