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 (
    64234, 64233, 64232, 64231, 64230, 64229, 
    64228, 64227, 64226, 64225, 64224, 
    64223, 64222, 64221, 64220, 64219, 
    64218, 64217, 64216, 64215, 64214, 
    64213, 64212, 64211, 64210, 64209, 
    64208, 64207, 64206, 64205, 63600, 
    63570, 63569, 63568, 63566, 63565, 
    63564, 63563, 63562, 63561
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00115

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	127190	63561	1	0.000	A	A	A	A
MP3	127192	63562	1	0.000	A	A	A	A
MP3	127194	63563	1	0.000	A	A	A	A
MP3	127196	63564	1	0.000	A	A	A	A
MP3	127198	63565	1	0.000	A	A	A	A
MP3	127200	63566	1	0.000	A	A	A	A
MP3	127204	63568	1	0.000	A	A	A	A
MP3	127206	63569	1	0.000	A	A	A	A
MP3	127208	63570	1	0.000	A	A	A	A
MP3	127268	63600	1	0.000	A	A	A	A
MP3	128478	64205	1	0.000	A	A	A	A
MP3	128480	64206	1	0.000	A	A	A	A
MP3	128482	64207	1	0.000	A	A	A	A
MP3	128484	64208	1	0.000	A	A	A	A
MP3	128486	64209	1	0.000	A	A	A	A
MP3	128488	64210	1	0.000	A	A	A	A
MP3	128490	64211	1	0.000	A	A	A	A
MP3	128492	64212	1	0.000	A	A	A	A
MP3	128494	64213	1	0.000	A	A	A	A
MP3	128496	64214	1	0.000	A	A	A	A
MP3	128498	64215	1	0.000	A	A	A	A
MP3	128500	64216	1	0.000	A	A	A	A
MP3	128502	64217	1	0.000	A	A	A	A
MP3	128504	64218	1	0.000	A	A	A	A
MP3	128506	64219	1	0.000	A	A	A	A
MP3	128508	64220	1	0.000	A	A	A	A
MP3	128510	64221	1	0.000	A	A	A	A
MP3	128512	64222	1	0.000	A	A	A	A
MP3	128514	64223	1	0.000	A	A	A	A
MP3	128516	64224	1	0.000	A	A	A	A
MP3	128518	64225	1	0.000	A	A	A	A
MP3	128520	64226	1	0.000	A	A	A	A
MP3	128522	64227	1	0.000	A	A	A	A
MP3	128524	64228	1	0.000	A	A	A	A
MP3	128526	64229	1	0.000	A	A	A	A
MP3	128528	64230	1	0.000	A	A	A	A
MP3	128530	64231	1	0.000	A	A	A	A
MP3	128532	64232	1	0.000	A	A	A	A
MP3	128534	64233	1	0.000	A	A	A	A
MP3	128536	64234	1	0.000	A	A	A	A
WAV	127191	63561	2	0.300	A	A	A	A
WAV	127193	63562	2	0.300	A	A	A	A
WAV	127195	63563	2	0.300	A	A	A	A
WAV	127197	63564	2	0.300	A	A	A	A
WAV	127199	63565	2	0.300	A	A	A	A
WAV	127201	63566	2	0.300	A	A	A	A
WAV	127205	63568	2	0.300	A	A	A	A
WAV	127207	63569	2	0.300	A	A	A	A
WAV	127209	63570	2	0.300	A	A	A	A
WAV	127269	63600	2	0.300	A	A	A	A
WAV	128479	64205	2	0.300	A	A	A	A
WAV	128481	64206	2	0.300	A	A	A	A
WAV	128483	64207	2	0.300	A	A	A	A
WAV	128485	64208	2	0.300	A	A	A	A
WAV	128487	64209	2	0.300	A	A	A	A
WAV	128489	64210	2	0.300	A	A	A	A
WAV	128491	64211	2	0.300	A	A	A	A
WAV	128493	64212	2	0.300	A	A	A	A
WAV	128495	64213	2	0.300	A	A	A	A
WAV	128497	64214	2	0.300	A	A	A	A
WAV	128499	64215	2	0.300	A	A	A	A
WAV	128501	64216	2	0.300	A	A	A	A
WAV	128503	64217	2	0.300	A	A	A	A
WAV	128505	64218	2	0.300	A	A	A	A
WAV	128507	64219	2	0.300	A	A	A	A
WAV	128509	64220	2	0.300	A	A	A	A
WAV	128511	64221	2	0.300	A	A	A	A
WAV	128513	64222	2	0.300	A	A	A	A
WAV	128515	64223	2	0.300	A	A	A	A
WAV	128517	64224	2	0.300	A	A	A	A
WAV	128519	64225	2	0.300	A	A	A	A
WAV	128521	64226	2	0.300	A	A	A	A
WAV	128523	64227	2	0.300	A	A	A	A
WAV	128525	64228	2	0.300	A	A	A	A
WAV	128527	64229	2	0.300	A	A	A	A
WAV	128529	64230	2	0.300	A	A	A	A
WAV	128531	64231	2	0.300	A	A	A	A
WAV	128533	64232	2	0.300	A	A	A	A
WAV	128535	64233	2	0.300	A	A	A	A
WAV	128537	64234	2	0.300	A	A	A	A