SELECT 
  c.product_id AS cur_product_id, 
  a.*, 
  b.option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (
    58884, 62123, 29986, 60914, 29983, 60749, 
    29992, 29989, 60748, 63034, 62012, 
    60739, 60745, 61430, 62240, 63755, 
    60753, 64625, 62259, 64624, 61340, 
    61337, 64616, 60746, 64617, 60736, 
    64615, 62252, 61336, 62253, 64614, 
    60731, 60726, 60750, 60734, 61388, 
    64622, 60741, 64623, 64626, 60747, 
    62254, 60730, 62260, 60740, 61387, 
    60742, 61171
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00173

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "a.position",
      "temporary_table": {
        "table": {
          "table_name": "c",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "product_id",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 62,
          "filtered": 100,
          "attached_condition": "c.product_id in (58884,62123,29986,60914,29983,60749,29992,29989,60748,63034,62012,60739,60745,61430,62240,63755,60753,64625,62259,64624,61340,61337,64616,60746,64617,60736,64615,62252,61336,62253,64614,60731,60726,60750,60734,61388,64622,60741,64623,64626,60747,62254,60730,62260,60740,61387,60742,61171)",
          "using_index": true
        },
        "table": {
          "table_name": "a",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY", "c_status"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["option_id"],
          "ref": ["cscart_migrate.c.option_id"],
          "rows": 1,
          "filtered": 73.88316345,
          "attached_condition": "a.product_id = 0 and a.`status` = 'A'"
        },
        "table": {
          "table_name": "b",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["option_id", "lang_code"],
          "ref": ["cscart_migrate.c.option_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(b.lang_code = 'en')"
        }
      }
    }
  }
}

Result