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 (
    64099, 64646, 64596, 64572, 64540, 64507, 
    64506, 64505, 64377, 64095, 63965, 
    63964, 64141, 64167, 63847, 64428, 
    64427, 64426, 64290, 63133, 64425, 
    64424, 64355, 64354, 64289, 64279, 
    64166, 63685, 63646, 63645, 63963, 
    63818, 63826, 64165, 64164, 64098, 
    64097, 63992, 63876, 63571
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00139

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	126334	63133	1	0.000	A	A	A	A
MP3	127210	63571	1	0.000	A	A	A	A
MP3	127358	63645	1	0.000	A	A	A	A
MP3	127360	63646	1	0.000	A	A	A	A
MP3	127438	63685	1	0.000	A	A	A	A
MP3	127704	63818	1	0.000	A	A	A	A
MP3	127720	63826	1	0.000	A	A	A	A
MP3	127762	63847	1	0.000	A	A	A	A
MP3	127820	63876	1	0.000	A	A	A	A
MP3	127994	63963	1	0.000	A	A	A	A
MP3	127996	63964	1	0.000	A	A	A	A
MP3	127998	63965	1	0.000	A	A	A	A
MP3	128052	63992	1	0.000	A	A	A	A
MP3	128258	64095	1	0.000	A	A	A	A
MP3	128262	64097	1	0.000	A	A	A	A
MP3	128264	64098	1	0.000	A	A	A	A
MP3	128266	64099	1	0.000	A	A	A	A
MP3	128350	64141	1	0.000	A	A	A	A
MP3	128396	64164	1	0.000	A	A	A	A
MP3	128398	64165	1	0.000	A	A	A	A
MP3	128400	64166	1	0.000	A	A	A	A
MP3	128402	64167	1	0.000	A	A	A	A
MP3	128626	64279	1	0.000	A	A	A	A
MP3	128646	64289	1	0.000	A	A	A	A
MP3	128648	64290	1	0.000	A	A	A	A
MP3	128776	64354	1	0.000	A	A	A	A
MP3	128778	64355	1	0.000	A	A	A	A
MP3	128822	64377	1	0.000	A	A	A	A
MP3	128916	64424	1	0.000	A	A	A	A
MP3	128918	64425	1	0.000	A	A	A	A
MP3	128920	64426	1	0.000	A	A	A	A
MP3	128922	64427	1	0.000	A	A	A	A
MP3	128924	64428	1	0.000	A	A	A	A
MP3	129078	64505	1	0.000	A	A	A	A
MP3	129080	64506	1	0.000	A	A	A	A
MP3	129082	64507	1	0.000	A	A	A	A
MP3	129148	64540	1	0.000	A	A	A	A
MP3	129212	64572	1	0.000	A	A	A	A
MP3	129260	64596	1	0.000	A	A	A	A
MP3	129360	64646	1	0.000	A	A	A	A
WAV	126335	63133	2	0.300	A	A	A	A
WAV	127211	63571	2	0.300	A	A	A	A
WAV	127359	63645	2	0.300	A	A	A	A
WAV	127361	63646	2	0.300	A	A	A	A
WAV	127439	63685	2	0.300	A	A	A	A
WAV	127705	63818	2	0.300	A	A	A	A
WAV	127721	63826	2	0.300	A	A	A	A
WAV	127763	63847	2	0.300	A	A	A	A
WAV	127821	63876	2	0.300	A	A	A	A
WAV	127995	63963	2	0.300	A	A	A	A
WAV	127997	63964	2	0.300	A	A	A	A
WAV	127999	63965	2	0.300	A	A	A	A
WAV	128053	63992	2	0.300	A	A	A	A
WAV	128259	64095	2	0.300	A	A	A	A
WAV	128263	64097	2	0.300	A	A	A	A
WAV	128265	64098	2	0.300	A	A	A	A
WAV	128267	64099	2	0.300	A	A	A	A
WAV	128351	64141	2	0.300	A	A	A	A
WAV	128397	64164	2	0.300	A	A	A	A
WAV	128399	64165	2	0.300	A	A	A	A
WAV	128401	64166	2	0.300	A	A	A	A
WAV	128403	64167	2	0.300	A	A	A	A
WAV	128627	64279	2	0.300	A	A	A	A
WAV	128647	64289	2	0.300	A	A	A	A
WAV	128649	64290	2	0.300	A	A	A	A
WAV	128777	64354	2	0.300	A	A	A	A
WAV	128779	64355	2	0.300	A	A	A	A
WAV	128823	64377	2	0.300	A	A	A	A
WAV	128917	64424	2	0.300	A	A	A	A
WAV	128919	64425	2	0.300	A	A	A	A
WAV	128921	64426	2	0.300	A	A	A	A
WAV	128923	64427	2	0.300	A	A	A	A
WAV	128925	64428	2	0.300	A	A	A	A
WAV	129079	64505	2	0.300	A	A	A	A
WAV	129081	64506	2	0.300	A	A	A	A
WAV	129083	64507	2	0.300	A	A	A	A
WAV	129149	64540	2	0.300	A	A	A	A
WAV	129213	64572	2	0.300	A	A	A	A
WAV	129261	64596	2	0.300	A	A	A	A
WAV	129361	64646	2	0.300	A	A	A	A