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 (
    64535, 64534, 64533, 64532, 64531, 64530, 
    64529, 64528, 64527, 64526, 64525, 
    64524, 64523, 64522, 64521, 64520, 
    64519, 64518, 64517, 64516, 64515, 
    64514, 64513, 64512, 64511, 64510, 
    64509, 64508, 64382, 63942, 63941, 
    63940, 63939, 63938, 63937, 64375, 
    63933, 63734, 63658, 63882
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00155

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	127384	63658	1	0.000	A	A	A	A
MP3	127536	63734	1	0.000	A	A	A	A
MP3	127832	63882	1	0.000	A	A	A	A
MP3	127934	63933	1	0.000	A	A	A	A
MP3	127942	63937	1	0.000	A	A	A	A
MP3	127944	63938	1	0.000	A	A	A	A
MP3	127946	63939	1	0.000	A	A	A	A
MP3	127948	63940	1	0.000	A	A	A	A
MP3	127950	63941	1	0.000	A	A	A	A
MP3	127952	63942	1	0.000	A	A	A	A
MP3	128818	64375	1	0.000	A	A	A	A
MP3	128832	64382	1	0.000	A	A	A	A
MP3	129084	64508	1	0.000	A	A	A	A
MP3	129086	64509	1	0.000	A	A	A	A
MP3	129088	64510	1	0.000	A	A	A	A
MP3	129090	64511	1	0.000	A	A	A	A
MP3	129092	64512	1	0.000	A	A	A	A
MP3	129094	64513	1	0.000	A	A	A	A
MP3	129096	64514	1	0.000	A	A	A	A
MP3	129098	64515	1	0.000	A	A	A	A
MP3	129100	64516	1	0.000	A	A	A	A
MP3	129102	64517	1	0.000	A	A	A	A
MP3	129104	64518	1	0.000	A	A	A	A
MP3	129106	64519	1	0.000	A	A	A	A
MP3	129108	64520	1	0.000	A	A	A	A
MP3	129110	64521	1	0.000	A	A	A	A
MP3	129112	64522	1	0.000	A	A	A	A
MP3	129114	64523	1	0.000	A	A	A	A
MP3	129116	64524	1	0.000	A	A	A	A
MP3	129118	64525	1	0.000	A	A	A	A
MP3	129120	64526	1	0.000	A	A	A	A
MP3	129122	64527	1	0.000	A	A	A	A
MP3	129124	64528	1	0.000	A	A	A	A
MP3	129126	64529	1	0.000	A	A	A	A
MP3	129128	64530	1	0.000	A	A	A	A
MP3	129130	64531	1	0.000	A	A	A	A
MP3	129132	64532	1	0.000	A	A	A	A
MP3	129134	64533	1	0.000	A	A	A	A
MP3	129136	64534	1	0.000	A	A	A	A
MP3	129138	64535	1	0.000	A	A	A	A
WAV	127385	63658	2	0.300	A	A	A	A
WAV	127537	63734	2	0.300	A	A	A	A
WAV	127833	63882	2	0.300	A	A	A	A
WAV	127935	63933	2	0.300	A	A	A	A
WAV	127943	63937	2	0.300	A	A	A	A
WAV	127945	63938	2	0.300	A	A	A	A
WAV	127947	63939	2	0.300	A	A	A	A
WAV	127949	63940	2	0.300	A	A	A	A
WAV	127951	63941	2	0.300	A	A	A	A
WAV	127953	63942	2	0.300	A	A	A	A
WAV	128819	64375	2	0.300	A	A	A	A
WAV	128833	64382	2	0.300	A	A	A	A
WAV	129085	64508	2	0.300	A	A	A	A
WAV	129087	64509	2	0.300	A	A	A	A
WAV	129089	64510	2	0.300	A	A	A	A
WAV	129091	64511	2	0.300	A	A	A	A
WAV	129093	64512	2	0.300	A	A	A	A
WAV	129095	64513	2	0.300	A	A	A	A
WAV	129097	64514	2	0.300	A	A	A	A
WAV	129099	64515	2	0.300	A	A	A	A
WAV	129101	64516	2	0.300	A	A	A	A
WAV	129103	64517	2	0.300	A	A	A	A
WAV	129105	64518	2	0.300	A	A	A	A
WAV	129107	64519	2	0.300	A	A	A	A
WAV	129109	64520	2	0.300	A	A	A	A
WAV	129111	64521	2	0.300	A	A	A	A
WAV	129113	64522	2	0.300	A	A	A	A
WAV	129115	64523	2	0.300	A	A	A	A
WAV	129117	64524	2	0.300	A	A	A	A
WAV	129119	64525	2	0.300	A	A	A	A
WAV	129121	64526	2	0.300	A	A	A	A
WAV	129123	64527	2	0.300	A	A	A	A
WAV	129125	64528	2	0.300	A	A	A	A
WAV	129127	64529	2	0.300	A	A	A	A
WAV	129129	64530	2	0.300	A	A	A	A
WAV	129131	64531	2	0.300	A	A	A	A
WAV	129133	64532	2	0.300	A	A	A	A
WAV	129135	64533	2	0.300	A	A	A	A
WAV	129137	64534	2	0.300	A	A	A	A
WAV	129139	64535	2	0.300	A	A	A	A