UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'd97Fyhnd5wGECqXrlpK4xFRzEy3i7CzoZiTwaCeGJvI=' 
WHERE 
  key_id = '8474aa2974293a44e61d572f825ba21b0375ff1aee368b3e8f72fa5bf82184ef' 
  AND (
    token = 'd97Fyhnd5wGECqXrlpK4xFRzEy3i7CzoZiTwaCeGJvI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038