SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'f1fc06a5d4dc3e33c3fca9cb55cbe4deed6004525ea6381060cd39b212a3dd33' 
  AND token = 'GmT1D26wz6eqFP6WvJPenT7YkHt1mh2nS0zt98y7ll4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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