SELECT 
  1 
FROM 
  cscart_june_setuplock_keys 
WHERE 
  key_id = '06509293bd124c8275bf4e164f0a2f23bc2ef3ea6ab33a0c74167b752ed1f9fe' 
  AND token = 'M9sTi36b2ni3D+sA8NCXtSFn4/Nj9w97uOQewjjjhrQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}