SELECT 
  1 
FROM 
  cscart_aprillock_keys 
WHERE 
  key_id = '0175beca2a83b36aa895ac8f45629c9f8b6a9f58e1b803a80d3dd6cdd96f9500' 
  AND token = 'fV5LdG/iJdBOEj1KtoUcW17TDdRjT8c6PuseVmHZbyg=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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