UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+K9Xg7oIgmzetsjwv69MCawqI5mXzvAwFJjoj8Pa4XU=' 
WHERE 
  key_id = '9cfd205dca63207044678dd0db4a785a1dbe96f1f6d044109299c73cb3cbdc38' 
  AND (
    token = '+K9Xg7oIgmzetsjwv69MCawqI5mXzvAwFJjoj8Pa4XU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044