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 (
    63805, 63804, 63733, 63641, 63640, 63638, 
    63636, 63635, 63419, 63350, 63349, 
    63191, 63185, 62977, 62976, 60692, 
    63637, 63242, 63598, 63591, 63139, 
    63136, 63130, 62978, 62975, 60554, 
    60553, 60552, 63245, 63483, 63062, 
    63061, 63060, 63059, 63058, 63057, 
    63056, 63055, 63054, 63053
  ) 
  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	121172	60552	1	0.000	A	A	A	A
MP3	121174	60553	1	0.000	A	A	A	A
MP3	121176	60554	1	0.000	A	A	A	A
MP3	121452	60692	1	0.000	A	A	A	A
MP3	126018	62975	1	0.000	A	A	A	A
MP3	126020	62976	1	0.000	A	A	A	A
MP3	126022	62977	1	0.000	A	A	A	A
MP3	126024	62978	1	0.000	A	A	A	A
MP3	126174	63053	1	0.000	A	A	A	A
MP3	126176	63054	1	0.000	A	A	A	A
MP3	126178	63055	1	0.000	A	A	A	A
MP3	126180	63056	1	0.000	A	A	A	A
MP3	126182	63057	1	0.000	A	A	A	A
MP3	126184	63058	1	0.000	A	A	A	A
MP3	126186	63059	1	0.000	A	A	A	A
MP3	126188	63060	1	0.000	A	A	A	A
MP3	126190	63061	1	0.000	A	A	A	A
MP3	126192	63062	1	0.000	A	A	A	A
MP3	126328	63130	1	0.000	A	A	A	A
MP3	126340	63136	1	0.000	A	A	A	A
MP3	126346	63139	1	0.000	A	A	A	A
MP3	126438	63185	1	0.000	A	A	A	A
MP3	126450	63191	1	0.000	A	A	A	A
MP3	126552	63242	1	0.000	A	A	A	A
MP3	126558	63245	1	0.000	A	A	A	A
MP3	126766	63349	1	0.000	A	A	A	A
MP3	126768	63350	1	0.000	A	A	A	A
MP3	126906	63419	1	0.000	A	A	A	A
MP3	127034	63483	1	0.000	A	A	A	A
MP3	127250	63591	1	0.000	A	A	A	A
MP3	127264	63598	1	0.000	A	A	A	A
MP3	127338	63635	1	0.000	A	A	A	A
MP3	127340	63636	1	0.000	A	A	A	A
MP3	127342	63637	1	0.000	A	A	A	A
MP3	127344	63638	1	0.000	A	A	A	A
MP3	127348	63640	1	0.000	A	A	A	A
MP3	127350	63641	1	0.000	A	A	A	A
MP3	127534	63733	1	0.000	A	A	A	A
MP3	127676	63804	1	0.000	A	A	A	A
MP3	127678	63805	1	0.000	A	A	A	A
WAV	121173	60552	2	0.300	A	A	A	A
WAV	121175	60553	2	0.300	A	A	A	A
WAV	121177	60554	2	0.300	A	A	A	A
WAV	121453	60692	2	0.300	A	A	A	A
WAV	126019	62975	2	0.300	A	A	A	A
WAV	126021	62976	2	0.300	A	A	A	A
WAV	126023	62977	2	0.300	A	A	A	A
WAV	126025	62978	2	0.300	A	A	A	A
WAV	126175	63053	2	0.300	A	A	A	A
WAV	126177	63054	2	0.300	A	A	A	A
WAV	126179	63055	2	0.300	A	A	A	A
WAV	126181	63056	2	0.300	A	A	A	A
WAV	126183	63057	2	0.300	A	A	A	A
WAV	126185	63058	2	0.300	A	A	A	A
WAV	126187	63059	2	0.300	A	A	A	A
WAV	126189	63060	2	0.300	A	A	A	A
WAV	126191	63061	2	0.300	A	A	A	A
WAV	126193	63062	2	0.300	A	A	A	A
WAV	126329	63130	2	0.300	A	A	A	A
WAV	126341	63136	2	0.300	A	A	A	A
WAV	126347	63139	2	0.300	A	A	A	A
WAV	126439	63185	2	0.300	A	A	A	A
WAV	126451	63191	2	0.300	A	A	A	A
WAV	126553	63242	2	0.300	A	A	A	A
WAV	126559	63245	2	0.300	A	A	A	A
WAV	126767	63349	2	0.300	A	A	A	A
WAV	126769	63350	2	0.300	A	A	A	A
WAV	126907	63419	2	0.300	A	A	A	A
WAV	127035	63483	2	0.300	A	A	A	A
WAV	127251	63591	2	0.300	A	A	A	A
WAV	127265	63598	2	0.300	A	A	A	A
WAV	127339	63635	2	0.300	A	A	A	A
WAV	127341	63636	2	0.300	A	A	A	A
WAV	127343	63637	2	0.300	A	A	A	A
WAV	127345	63638	2	0.300	A	A	A	A
WAV	127349	63640	2	0.300	A	A	A	A
WAV	127351	63641	2	0.300	A	A	A	A
WAV	127535	63733	2	0.300	A	A	A	A
WAV	127677	63804	2	0.300	A	A	A	A
WAV	127679	63805	2	0.300	A	A	A	A