SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = 'aecd76ea0144c5c11c45564c7a012cac33c2953c2147a5a9249f3d6c40d2b3c8' 
  AND token = 'YCKZsPekL9z9XPrCpxGXLZpTDeXV/j25bChwjzIVYAU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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