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 (
    63132, 64081, 63082, 63081, 63080, 63079, 
    63078, 63077, 63076, 63075, 63074, 
    63073, 63072, 63071, 63070, 63069, 
    63068, 63067, 63066, 63065, 63064, 
    63063, 63962, 63961, 63930, 63803, 
    63408, 63407, 63960, 63931, 63844, 
    63802, 63652, 63639, 63482, 63161, 
    63135, 63134, 63131, 63484
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00152

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	126194	63063	1	0.000	A	A	A	A
MP3	126196	63064	1	0.000	A	A	A	A
MP3	126198	63065	1	0.000	A	A	A	A
MP3	126200	63066	1	0.000	A	A	A	A
MP3	126202	63067	1	0.000	A	A	A	A
MP3	126204	63068	1	0.000	A	A	A	A
MP3	126206	63069	1	0.000	A	A	A	A
MP3	126208	63070	1	0.000	A	A	A	A
MP3	126210	63071	1	0.000	A	A	A	A
MP3	126212	63072	1	0.000	A	A	A	A
MP3	126214	63073	1	0.000	A	A	A	A
MP3	126216	63074	1	0.000	A	A	A	A
MP3	126218	63075	1	0.000	A	A	A	A
MP3	126220	63076	1	0.000	A	A	A	A
MP3	126222	63077	1	0.000	A	A	A	A
MP3	126224	63078	1	0.000	A	A	A	A
MP3	126226	63079	1	0.000	A	A	A	A
MP3	126228	63080	1	0.000	A	A	A	A
MP3	126230	63081	1	0.000	A	A	A	A
MP3	126232	63082	1	0.000	A	A	A	A
MP3	126330	63131	1	0.000	A	A	A	A
MP3	126332	63132	1	0.000	A	A	A	A
MP3	126336	63134	1	0.000	A	A	A	A
MP3	126338	63135	1	0.000	A	A	A	A
MP3	126390	63161	1	0.000	A	A	A	A
MP3	126882	63407	1	0.000	A	A	A	A
MP3	126884	63408	1	0.000	A	A	A	A
MP3	127032	63482	1	0.000	A	A	A	A
MP3	127036	63484	1	0.000	A	A	A	A
MP3	127346	63639	1	0.000	A	A	A	A
MP3	127372	63652	1	0.000	A	A	A	A
MP3	127672	63802	1	0.000	A	A	A	A
MP3	127674	63803	1	0.000	A	A	A	A
MP3	127756	63844	1	0.000	A	A	A	A
MP3	127928	63930	1	0.000	A	A	A	A
MP3	127930	63931	1	0.000	A	A	A	A
MP3	127988	63960	1	0.000	A	A	A	A
MP3	127990	63961	1	0.000	A	A	A	A
MP3	127992	63962	1	0.000	A	A	A	A
MP3	128230	64081	1	0.000	A	A	A	A
WAV	126195	63063	2	0.300	A	A	A	A
WAV	126197	63064	2	0.300	A	A	A	A
WAV	126199	63065	2	0.300	A	A	A	A
WAV	126201	63066	2	0.300	A	A	A	A
WAV	126203	63067	2	0.300	A	A	A	A
WAV	126205	63068	2	0.300	A	A	A	A
WAV	126207	63069	2	0.300	A	A	A	A
WAV	126209	63070	2	0.300	A	A	A	A
WAV	126211	63071	2	0.300	A	A	A	A
WAV	126213	63072	2	0.300	A	A	A	A
WAV	126215	63073	2	0.300	A	A	A	A
WAV	126217	63074	2	0.300	A	A	A	A
WAV	126219	63075	2	0.300	A	A	A	A
WAV	126221	63076	2	0.300	A	A	A	A
WAV	126223	63077	2	0.300	A	A	A	A
WAV	126225	63078	2	0.300	A	A	A	A
WAV	126227	63079	2	0.300	A	A	A	A
WAV	126229	63080	2	0.300	A	A	A	A
WAV	126231	63081	2	0.300	A	A	A	A
WAV	126233	63082	2	0.300	A	A	A	A
WAV	126331	63131	2	0.300	A	A	A	A
WAV	126333	63132	2	0.300	A	A	A	A
WAV	126337	63134	2	0.300	A	A	A	A
WAV	126339	63135	2	0.300	A	A	A	A
WAV	126391	63161	2	0.300	A	A	A	A
WAV	126883	63407	2	0.300	A	A	A	A
WAV	126885	63408	2	0.300	A	A	A	A
WAV	127033	63482	2	0.300	A	A	A	A
WAV	127037	63484	2	0.300	A	A	A	A
WAV	127347	63639	2	0.300	A	A	A	A
WAV	127373	63652	2	0.300	A	A	A	A
WAV	127673	63802	2	0.300	A	A	A	A
WAV	127675	63803	2	0.300	A	A	A	A
WAV	127757	63844	2	0.300	A	A	A	A
WAV	127929	63930	2	0.300	A	A	A	A
WAV	127931	63931	2	0.300	A	A	A	A
WAV	127989	63960	2	0.300	A	A	A	A
WAV	127991	63961	2	0.300	A	A	A	A
WAV	127993	63962	2	0.300	A	A	A	A
WAV	128231	64081	2	0.300	A	A	A	A