SELECT 
  destination_id, 
  delivery_time 
FROM 
  cscart_shipping_time_descriptions 
WHERE 
  destination_id IN (
    1, 102, 15, 61, 65, 108, 109, 110, 16, 111, 
    92, 91, 112, 63, 17, 113, 126, 18, 127, 
    19, 72, 132, 134, 135, 20, 136, 21, 22, 
    23, 128, 129, 89, 130, 24, 25, 26, 114, 
    56, 27, 115, 116, 117, 118, 28, 29, 30, 
    9, 144, 131, 88, 59, 133, 57, 31, 32, 33, 
    34, 35, 36, 82, 37, 38, 39, 40, 119, 41, 
    120, 121, 122, 123, 124, 106, 42, 43, 
    125, 44, 45, 46, 137, 103, 11, 105, 47, 
    12, 48, 49, 90, 50, 138, 51, 52, 139, 100, 
    60, 53, 140, 14, 54, 107, 55, 62, 141, 
    142, 104, 13, 143, 84, 93, 85, 94, 86, 
    95, 87, 96, 97, 98, 101
  ) 
  AND lang_code = 'en' 
  AND shipping_id = 165

Query time 0.00097

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "24.51"
    },
    "table": {
      "table_name": "cscart_shipping_time_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "shipping_id",
        "destination_id",
        "lang_code"
      ],
      "key_length": "14",
      "rows_examined_per_scan": 117,
      "rows_produced_per_join": 5,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "1.11",
        "eval_cost": "1.17",
        "prefix_cost": "24.51",
        "data_read_per_join": "2K"
      },
      "used_columns": [
        "shipping_id",
        "destination_id",
        "lang_code",
        "delivery_time"
      ],
      "attached_condition": "((`webmarco`.`cscart_shipping_time_descriptions`.`shipping_id` = 165) and (`webmarco`.`cscart_shipping_time_descriptions`.`destination_id` in (1,102,15,61,65,108,109,110,16,111,92,91,112,63,17,113,126,18,127,19,72,132,134,135,20,136,21,22,23,128,129,89,130,24,25,26,114,56,27,115,116,117,118,28,29,30,9,144,131,88,59,133,57,31,32,33,34,35,36,82,37,38,39,40,119,41,120,121,122,123,124,106,42,43,125,44,45,46,137,103,11,105,47,12,48,49,90,50,138,51,52,139,100,60,53,140,14,54,107,55,62,141,142,104,13,143,84,93,85,94,86,95,87,96,97,98,101)) and (`webmarco`.`cscart_shipping_time_descriptions`.`lang_code` = 'en'))"
    }
  }
}