SELECT 
  data, 
  expiry 
FROM 
  cscart_cache 
WHERE 
  name = 'product_filters.C_GET_categories_view.0_1.ru.RUBproduct_filters_products_count_d00975798b3973ff7f58a399eb0d545a' 
  AND company_id = 0 
  AND (
    expiry = 0 
    OR expiry > 1776749912
  )

Query time 0.00036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}