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 (
    64386, 64385, 64502, 64658, 64651, 64650, 
    64199, 64198, 64197, 64195, 64194, 
    64193, 64192, 64191, 64190, 64189, 
    64188, 64187, 64186, 64185, 64184, 
    64183, 64179, 64178, 64176, 64174, 
    64121, 64120, 64119, 64118, 64117, 
    64116, 64115, 64113, 64110, 64106, 
    64105, 64104, 64103, 64536
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00137

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	128274	64103	1	0.000	A	A	A	A
MP3	128276	64104	1	0.000	A	A	A	A
MP3	128278	64105	1	0.000	A	A	A	A
MP3	128280	64106	1	0.000	A	A	A	A
MP3	128288	64110	1	0.000	A	A	A	A
MP3	128294	64113	1	0.000	A	A	A	A
MP3	128298	64115	1	0.000	A	A	A	A
MP3	128300	64116	1	0.000	A	A	A	A
MP3	128302	64117	1	0.000	A	A	A	A
MP3	128304	64118	1	0.000	A	A	A	A
MP3	128306	64119	1	0.000	A	A	A	A
MP3	128308	64120	1	0.000	A	A	A	A
MP3	128310	64121	1	0.000	A	A	A	A
MP3	128416	64174	1	0.000	A	A	A	A
MP3	128420	64176	1	0.000	A	A	A	A
MP3	128424	64178	1	0.000	A	A	A	A
MP3	128426	64179	1	0.000	A	A	A	A
MP3	128434	64183	1	0.000	A	A	A	A
MP3	128436	64184	1	0.000	A	A	A	A
MP3	128438	64185	1	0.000	A	A	A	A
MP3	128440	64186	1	0.000	A	A	A	A
MP3	128442	64187	1	0.000	A	A	A	A
MP3	128444	64188	1	0.000	A	A	A	A
MP3	128446	64189	1	0.000	A	A	A	A
MP3	128448	64190	1	0.000	A	A	A	A
MP3	128450	64191	1	0.000	A	A	A	A
MP3	128452	64192	1	0.000	A	A	A	A
MP3	128454	64193	1	0.000	A	A	A	A
MP3	128456	64194	1	0.000	A	A	A	A
MP3	128458	64195	1	0.000	A	A	A	A
MP3	128462	64197	1	0.000	A	A	A	A
MP3	128464	64198	1	0.000	A	A	A	A
MP3	128466	64199	1	0.000	A	A	A	A
MP3	128838	64385	1	0.000	A	A	A	A
MP3	128840	64386	1	0.000	A	A	A	A
MP3	129072	64502	1	0.000	A	A	A	A
MP3	129140	64536	1	0.000	A	A	A	A
MP3	129368	64650	1	0.000	A	A	A	A
MP3	129370	64651	1	0.000	A	A	A	A
MP3	129384	64658	1	0.000	A	A	A	A
WAV	128275	64103	2	0.300	A	A	A	A
WAV	128277	64104	2	0.300	A	A	A	A
WAV	128279	64105	2	0.300	A	A	A	A
WAV	128281	64106	2	0.300	A	A	A	A
WAV	128289	64110	2	0.300	A	A	A	A
WAV	128295	64113	2	0.300	A	A	A	A
WAV	128299	64115	2	0.300	A	A	A	A
WAV	128301	64116	2	0.300	A	A	A	A
WAV	128303	64117	2	0.300	A	A	A	A
WAV	128305	64118	2	0.300	A	A	A	A
WAV	128307	64119	2	0.300	A	A	A	A
WAV	128309	64120	2	0.300	A	A	A	A
WAV	128311	64121	2	0.300	A	A	A	A
WAV	128417	64174	2	0.300	A	A	A	A
WAV	128421	64176	2	0.300	A	A	A	A
WAV	128425	64178	2	0.300	A	A	A	A
WAV	128427	64179	2	0.300	A	A	A	A
WAV	128435	64183	2	0.300	A	A	A	A
WAV	128437	64184	2	0.300	A	A	A	A
WAV	128439	64185	2	0.300	A	A	A	A
WAV	128441	64186	2	0.300	A	A	A	A
WAV	128443	64187	2	0.300	A	A	A	A
WAV	128445	64188	2	0.300	A	A	A	A
WAV	128447	64189	2	0.300	A	A	A	A
WAV	128449	64190	2	0.300	A	A	A	A
WAV	128451	64191	2	0.300	A	A	A	A
WAV	128453	64192	2	0.300	A	A	A	A
WAV	128455	64193	2	0.300	A	A	A	A
WAV	128457	64194	2	0.300	A	A	A	A
WAV	128459	64195	2	0.300	A	A	A	A
WAV	128463	64197	2	0.300	A	A	A	A
WAV	128465	64198	2	0.300	A	A	A	A
WAV	128467	64199	2	0.300	A	A	A	A
WAV	128839	64385	2	0.300	A	A	A	A
WAV	128841	64386	2	0.300	A	A	A	A
WAV	129073	64502	2	0.300	A	A	A	A
WAV	129141	64536	2	0.300	A	A	A	A
WAV	129369	64650	2	0.300	A	A	A	A
WAV	129371	64651	2	0.300	A	A	A	A
WAV	129385	64658	2	0.300	A	A	A	A