UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'le1fmdFYz5PX871/CK9t94gcOgnY9f8Y+OlMXrLghAA=' 
WHERE 
  key_id = '3cf66a7567366279d69d78eb0cc06af943130a4f8052316548bdbe1c97740ed9' 
  AND (
    token = 'le1fmdFYz5PX871/CK9t94gcOgnY9f8Y+OlMXrLghAA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030