SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '19a67f7f93a37d023cc2fe0f3bdb91e878a94b8961b1986e3b7938950604e218' 
  AND token = 'Shcrd64h5enUQnYCjkO4N7iE0ht/EaIi/WKBB64ozGE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00032

JSON explain

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