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 (
    63560, 63559, 63558, 63557, 63556, 63555, 
    63554, 63846, 63487, 63683, 63653, 
    73245, 73244, 73243, 73242, 73241, 
    73240, 73239, 73238, 73237, 73236, 
    73235, 73234, 73233, 73232, 73231, 
    73230, 73229, 73228, 73227, 73226, 
    73225, 73224, 73223, 73222, 73221, 
    73220, 73219, 63672, 63472
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00166

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	127012	63472	1	0.000	A	A	A	A
MP3	127042	63487	1	0.000	A	A	A	A
MP3	127176	63554	1	0.000	A	A	A	A
MP3	127178	63555	1	0.000	A	A	A	A
MP3	127180	63556	1	0.000	A	A	A	A
MP3	127182	63557	1	0.000	A	A	A	A
MP3	127184	63558	1	0.000	A	A	A	A
MP3	127186	63559	1	0.000	A	A	A	A
MP3	127188	63560	1	0.000	A	A	A	A
MP3	127374	63653	1	0.000	A	A	A	A
MP3	127412	63672	1	0.000	A	A	A	A
MP3	127434	63683	1	0.000	A	A	A	A
MP3	127760	63846	1	0.000	A	A	A	A
MP3	146952	73219	1	0.000	A	A	A	A
MP3	146954	73220	1	0.000	A	A	A	A
MP3	146956	73221	1	0.000	A	A	A	A
MP3	146958	73222	1	0.000	A	A	A	A
MP3	146960	73223	1	0.000	A	A	A	A
MP3	146962	73224	1	0.000	A	A	A	A
MP3	146964	73225	1	0.000	A	A	A	A
MP3	146966	73226	1	0.000	A	A	A	A
MP3	146968	73227	1	0.000	A	A	A	A
MP3	146970	73228	1	0.000	A	A	A	A
MP3	146972	73229	1	0.000	A	A	A	A
MP3	146974	73230	1	0.000	A	A	A	A
MP3	146976	73231	1	0.000	A	A	A	A
MP3	146978	73232	1	0.000	A	A	A	A
MP3	146980	73233	1	0.000	A	A	A	A
MP3	146982	73234	1	0.000	A	A	A	A
MP3	146984	73235	1	0.000	A	A	A	A
MP3	146986	73236	1	0.000	A	A	A	A
MP3	146988	73237	1	0.000	A	A	A	A
MP3	146990	73238	1	0.000	A	A	A	A
MP3	146992	73239	1	0.000	A	A	A	A
MP3	146994	73240	1	0.000	A	A	A	A
MP3	146996	73241	1	0.000	A	A	A	A
MP3	146998	73242	1	0.000	A	A	A	A
MP3	147000	73243	1	0.000	A	A	A	A
MP3	147002	73244	1	0.000	A	A	A	A
MP3	147004	73245	1	0.000	A	A	A	A
WAV	127013	63472	2	0.300	A	A	A	A
WAV	127043	63487	2	0.300	A	A	A	A
WAV	127177	63554	2	0.300	A	A	A	A
WAV	127179	63555	2	0.300	A	A	A	A
WAV	127181	63556	2	0.300	A	A	A	A
WAV	127183	63557	2	0.300	A	A	A	A
WAV	127185	63558	2	0.300	A	A	A	A
WAV	127187	63559	2	0.300	A	A	A	A
WAV	127189	63560	2	0.300	A	A	A	A
WAV	127375	63653	2	0.300	A	A	A	A
WAV	127413	63672	2	0.300	A	A	A	A
WAV	127435	63683	2	0.300	A	A	A	A
WAV	127761	63846	2	0.300	A	A	A	A
WAV	146953	73219	2	0.300	A	A	A	A
WAV	146955	73220	2	0.300	A	A	A	A
WAV	146957	73221	2	0.300	A	A	A	A
WAV	146959	73222	2	0.300	A	A	A	A
WAV	146961	73223	2	0.300	A	A	A	A
WAV	146963	73224	2	0.300	A	A	A	A
WAV	146965	73225	2	0.300	A	A	A	A
WAV	146967	73226	2	0.300	A	A	A	A
WAV	146969	73227	2	0.300	A	A	A	A
WAV	146971	73228	2	0.300	A	A	A	A
WAV	146973	73229	2	0.300	A	A	A	A
WAV	146975	73230	2	0.300	A	A	A	A
WAV	146977	73231	2	0.300	A	A	A	A
WAV	146979	73232	2	0.300	A	A	A	A
WAV	146981	73233	2	0.300	A	A	A	A
WAV	146983	73234	2	0.300	A	A	A	A
WAV	146985	73235	2	0.300	A	A	A	A
WAV	146987	73236	2	0.300	A	A	A	A
WAV	146989	73237	2	0.300	A	A	A	A
WAV	146991	73238	2	0.300	A	A	A	A
WAV	146993	73239	2	0.300	A	A	A	A
WAV	146995	73240	2	0.300	A	A	A	A
WAV	146997	73241	2	0.300	A	A	A	A
WAV	146999	73242	2	0.300	A	A	A	A
WAV	147001	73243	2	0.300	A	A	A	A
WAV	147003	73244	2	0.300	A	A	A	A
WAV	147005	73245	2	0.300	A	A	A	A