Sandbox

SELECT 
  b.variant_name, 
  a.*, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier, 
    a.modifier
  ) as modifier, 
  IF(
    shared_option_variants.variant_id IS NOT NULL, 
    shared_option_variants.modifier_type, 
    a.modifier_type
  ) as modifier_type 
FROM 
  cscart_product_option_variants AS a 
  LEFT JOIN cscart_product_option_variants_descriptions AS b ON b.variant_id = a.variant_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_option_variants shared_option_variants ON shared_option_variants.variant_id = a.variant_id 
  AND shared_option_variants.company_id = 1 
WHERE 
  1 
  AND a.option_id IN (
    91057, 91056, 91055, 91054, 91053, 91052, 
    91051, 91050, 91049, 91048, 91047, 
    90369, 90367, 90366, 90362, 90361, 
    90360, 90359, 90358, 90357, 90356, 
    90355, 90354, 90353, 90352, 90351, 
    90350, 90349, 90348, 90347, 90346, 
    90345, 90344, 90343, 90342, 90551, 
    90550, 90333, 90332, 90331
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00159

Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	status,option_id,option_id_2	option_id	6		80	Using index condition; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	9	toolboxdigitalshop_dev.a.variant_id,const	1	Using where
1	SIMPLE	shared_option_variants	eq_ref	PRIMARY,company_id	PRIMARY	7	toolboxdigitalshop_dev.a.variant_id,const	1

Result

variant_name	variant_id	option_id	position	modifier	modifier_type	weight_modifier_type	point_modifier_type	status
MP3	181198	90331	1	0.000	A	A	A	A
MP3	181200	90332	1	0.000	A	A	A	A
MP3	181202	90333	1	0.000	A	A	A	A
MP3	181220	90342	1	0.000	A	A	A	A
MP3	181222	90343	1	0.000	A	A	A	A
MP3	181224	90344	1	0.000	A	A	A	A
MP3	181226	90345	1	0.000	A	A	A	A
MP3	181228	90346	1	0.000	A	A	A	A
MP3	181230	90347	1	0.000	A	A	A	A
MP3	181232	90348	1	0.000	A	A	A	A
MP3	181234	90349	1	0.000	A	A	A	A
MP3	181236	90350	1	0.000	A	A	A	A
MP3	181238	90351	1	0.000	A	A	A	A
MP3	181240	90352	1	0.000	A	A	A	A
MP3	181242	90353	1	0.000	A	A	A	A
MP3	181244	90354	1	0.000	A	A	A	A
MP3	181246	90355	1	0.000	A	A	A	A
MP3	181248	90356	1	0.000	A	A	A	A
MP3	181250	90357	1	0.000	A	A	A	A
MP3	181252	90358	1	0.000	A	A	A	A
MP3	181254	90359	1	0.000	A	A	A	A
MP3	181256	90360	1	0.000	A	A	A	A
MP3	181258	90361	1	0.000	A	A	A	A
MP3	181260	90362	1	0.000	A	A	A	A
MP3	181268	90366	1	0.000	A	A	A	A
MP3	181270	90367	1	0.000	A	A	A	A
MP3	181274	90369	1	0.000	A	A	A	A
MP3	181636	90550	1	0.000	A	A	A	A
MP3	181638	90551	1	0.000	A	A	A	A
MP3	182630	91047	1	0.000	A	A	A	A
MP3	182632	91048	1	0.000	A	A	A	A
MP3	182634	91049	1	0.000	A	A	A	A
MP3	182636	91050	1	0.000	A	A	A	A
MP3	182638	91051	1	0.000	A	A	A	A
MP3	182640	91052	1	0.000	A	A	A	A
MP3	182642	91053	1	0.000	A	A	A	A
MP3	182644	91054	1	0.000	A	A	A	A
MP3	182646	91055	1	0.000	A	A	A	A
MP3	182648	91056	1	0.000	A	A	A	A
MP3	182650	91057	1	0.000	A	A	A	A
WAV	181199	90331	2	0.300	A	A	A	A
WAV	181201	90332	2	0.300	A	A	A	A
WAV	181203	90333	2	0.300	A	A	A	A
WAV	181221	90342	2	0.300	A	A	A	A
WAV	181223	90343	2	0.300	A	A	A	A
WAV	181225	90344	2	0.300	A	A	A	A
WAV	181227	90345	2	0.300	A	A	A	A
WAV	181229	90346	2	0.300	A	A	A	A
WAV	181231	90347	2	0.300	A	A	A	A
WAV	181233	90348	2	0.300	A	A	A	A
WAV	181235	90349	2	0.300	A	A	A	A
WAV	181237	90350	2	0.300	A	A	A	A
WAV	181239	90351	2	0.300	A	A	A	A
WAV	181241	90352	2	0.300	A	A	A	A
WAV	181243	90353	2	0.300	A	A	A	A
WAV	181245	90354	2	0.300	A	A	A	A
WAV	181247	90355	2	0.300	A	A	A	A
WAV	181249	90356	2	0.300	A	A	A	A
WAV	181251	90357	2	0.300	A	A	A	A
WAV	181253	90358	2	0.300	A	A	A	A
WAV	181255	90359	2	0.300	A	A	A	A
WAV	181257	90360	2	0.300	A	A	A	A
WAV	181259	90361	2	0.300	A	A	A	A
WAV	181261	90362	2	0.300	A	A	A	A
WAV	181269	90366	2	0.300	A	A	A	A
WAV	181271	90367	2	0.300	A	A	A	A
WAV	181275	90369	2	0.300	A	A	A	A
WAV	181637	90550	2	0.300	A	A	A	A
WAV	181639	90551	2	0.300	A	A	A	A
WAV	182631	91047	2	0.300	A	A	A	A
WAV	182633	91048	2	0.300	A	A	A	A
WAV	182635	91049	2	0.300	A	A	A	A
WAV	182637	91050	2	0.300	A	A	A	A
WAV	182639	91051	2	0.300	A	A	A	A
WAV	182641	91052	2	0.300	A	A	A	A
WAV	182643	91053	2	0.300	A	A	A	A
WAV	182645	91054	2	0.300	A	A	A	A
WAV	182647	91055	2	0.300	A	A	A	A
WAV	182649	91056	2	0.300	A	A	A	A
WAV	182651	91057	2	0.300	A	A	A	A