SELECT 
  data, 
  expiry 
FROM 
  cscart_cache 
WHERE 
  name = 'product_filters_filters.cache_customerproduct_filters_filters_cc28fbfeeff747032386844f33410c8c' 
  AND company_id = 0 
  AND (
    expiry = 0 
    OR expiry > 1776164603
  )

Query time 0.00113

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_cache",
          "access_type": "const",
          "possible_keys": ["PRIMARY", "name", "company_id"],
          "key": "PRIMARY",
          "key_length": "771",
          "used_key_parts": ["name", "company_id"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

data expiry
a:4:{i:10;a:12:{s:10:"feature_id";s:2:"18";s:9:"filter_id";s:2:"10";s:10:"field_type";s:0:"";s:8:"round_to";s:1:"1";s:7:"display";s:1:"Y";s:13:"display_count";s:2:"10";s:6:"filter";s:10:"Бренд";s:12:"feature_type";s:1:"E";s:12:"filter_style";s:8:"checkbox";s:6:"prefix";s:0:"";s:6:"suffix";s:0:"";s:18:"yml2_variants_unit";s:0:"";}i:312;a:12:{s:10:"feature_id";s:3:"548";s:9:"filter_id";s:3:"312";s:10:"field_type";s:0:"";s:8:"round_to";s:4:"0.01";s:7:"display";s:1:"Y";s:13:"display_count";s:2:"10";s:6:"filter";s:12:"Размер";s:12:"feature_type";s:1:"S";s:12:"filter_style";s:8:"checkbox";s:6:"prefix";s:0:"";s:6:"suffix";s:0:"";s:18:"yml2_variants_unit";s:0:"";}i:313;a:12:{s:10:"feature_id";s:3:"549";s:9:"filter_id";s:3:"313";s:10:"field_type";s:0:"";s:8:"round_to";s:4:"0.01";s:7:"display";s:1:"Y";s:13:"display_count";s:2:"10";s:6:"filter";s:8:"Цвет";s:12:"feature_type";s:1:"S";s:12:"filter_style";s:8:"checkbox";s:6:"prefix";s:0:"";s:6:"suffix";s:0:"";s:18:"yml2_variants_unit";s:0:"";}i:1;a:12:{s:10:"feature_id";s:1:"0";s:9:"filter_id";s:1:"1";s:10:"field_type";s:1:"P";s:8:"round_to";s:1:"1";s:7:"display";s:1:"Y";s:13:"display_count";s:2:"10";s:6:"filter";s:8:"Цена";s:12:"feature_type";N;s:12:"filter_style";N;s:6:"prefix";N;s:6:"suffix";N;s:18:"yml2_variants_unit";N;}} 0