SELECT 
  data, 
  expiry 
FROM 
  cscart_cache 
WHERE 
  name = 'abt__ut2.cache_customer_en_54e630a02cad3cd583d66354c82a495b' 
  AND company_id = 0 
  AND (
    expiry = 0 
    OR expiry > 1781872988
  )

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_cache",
      "access_type": "const",
      "possible_keys": [
        "PRIMARY",
        "name",
        "company_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "name",
        "company_id"
      ],
      "key_length": "771",
      "ref": [
        "const",
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.00",
        "eval_cost": "0.20",
        "prefix_cost": "0.00",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "name",
        "company_id",
        "data",
        "expiry"
      ]
    }
  }
}

Result

data expiry
a:5:{s:7:"general";a:9:{s:12:"use_rounding";s:4:"full";s:19:"use_rounding_blocks";s:1:"Y";s:7:"buttons";a:5:{s:5:"style";s:14:"use_background";s:18:"use_text_uppercase";s:1:"N";s:10:"use_shadow";s:1:"N";s:12:"use_gradient";s:1:"N";s:13:"use_icon_cart";s:5:"type4";}s:20:"use_titles_uppercase";s:1:"N";s:6:"labels";a:4:{s:5:"style";s:12:"as_rectangle";s:11:"use_outline";s:1:"N";s:10:"use_shadow";s:1:"N";s:15:"use_text_shadow";s:1:"N";}s:18:"stars_rating_color";s:4:"#07c";s:29:"sticky_panel_background_color";s:7:"#ffffff";s:23:"sticky_panel_icon_color";s:4:"#07c";s:20:"browser_interface_bg";s:7:"#ffffff";}s:10:"containers";a:3:{s:26:"header_elements_brightness";s:5:"light";s:9:"top_panel";a:1:{s:6:"height";s:4:"33px";}s:6:"header";a:7:{s:6:"height";s:4:"70px";s:15:"add_header_mask";s:1:"Y";s:14:"add_delimiters";s:1:"N";s:23:"use_color_menu_on_hover";s:7:"#ffe77e";s:27:"use_color_elements_on_hover";s:7:"#ffe77e";s:15:"use_color_icons";s:7:"#1e1e1e";s:32:"use_animation_for_not_empty_cart";s:1:"N";}}s:12:"product_list";a:5:{s:9:"grid-list";a:1:{s:24:"product_name_font_weight";s:6:"normal";}s:16:"show_grid_border";s:18:"solid_with_margins";s:19:"mask_images_gallery";s:1:"Y";s:22:"use_elements_alignment";s:3:"use";s:25:"extend_grid_item_on_hover";s:1:"Y";}s:8:"products";a:4:{s:29:"use_color_buttons_add_to_cart";s:7:"#0077cc";s:19:"mask_images_gallery";s:1:"Y";s:23:"bordered_images_gallery";s:1:"N";s:14:"sticky_columns";s:1:"N";}s:6:"addons";a:2:{s:17:"ab__video_gallery";a:1:{s:8:"block_bg";s:7:"#1e1e1e";}s:19:"ab__deal_of_the_day";a:5:{s:16:"block_background";s:7:"#ffffff";s:17:"block_fonts_color";s:7:"#000000";s:28:"bright_color_promotion_title";s:1:"Y";s:14:"bordered_block";s:1:"Y";s:12:"shadow_block";s:1:"N";}}} 0