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 (
    63052, 63051, 63050, 63049, 63048, 63047, 
    63046, 63045, 63044, 63043, 62986, 
    63418, 63417, 63411, 63410, 63334, 
    63155, 62974, 62973, 62955, 62883, 
    60529, 63256, 63255, 63254, 63253, 
    63129, 63021, 63001, 62972, 62971, 
    62877, 60528, 62984, 62930, 62929, 
    61016, 62827, 63205, 63204
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00098

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	121124	60528	1	0.000	A	A	A	A
MP3	121126	60529	1	0.000	A	A	A	A
MP3	122100	61016	1	0.000	A	A	A	A
MP3	125722	62827	1	0.000	A	A	A	A
MP3	125822	62877	1	0.000	A	A	A	A
MP3	125834	62883	1	0.000	A	A	A	A
MP3	125926	62929	1	0.000	A	A	A	A
MP3	125928	62930	1	0.000	A	A	A	A
MP3	125978	62955	1	0.000	A	A	A	A
MP3	126010	62971	1	0.000	A	A	A	A
MP3	126012	62972	1	0.000	A	A	A	A
MP3	126014	62973	1	0.000	A	A	A	A
MP3	126016	62974	1	0.000	A	A	A	A
MP3	126036	62984	1	0.000	A	A	A	A
MP3	126040	62986	1	0.000	A	A	A	A
MP3	126070	63001	1	0.000	A	A	A	A
MP3	126110	63021	1	0.000	A	A	A	A
MP3	126154	63043	1	0.000	A	A	A	A
MP3	126156	63044	1	0.000	A	A	A	A
MP3	126158	63045	1	0.000	A	A	A	A
MP3	126160	63046	1	0.000	A	A	A	A
MP3	126162	63047	1	0.000	A	A	A	A
MP3	126164	63048	1	0.000	A	A	A	A
MP3	126166	63049	1	0.000	A	A	A	A
MP3	126168	63050	1	0.000	A	A	A	A
MP3	126170	63051	1	0.000	A	A	A	A
MP3	126172	63052	1	0.000	A	A	A	A
MP3	126326	63129	1	0.000	A	A	A	A
MP3	126378	63155	1	0.000	A	A	A	A
MP3	126476	63204	1	0.000	A	A	A	A
MP3	126478	63205	1	0.000	A	A	A	A
MP3	126574	63253	1	0.000	A	A	A	A
MP3	126576	63254	1	0.000	A	A	A	A
MP3	126578	63255	1	0.000	A	A	A	A
MP3	126580	63256	1	0.000	A	A	A	A
MP3	126736	63334	1	0.000	A	A	A	A
MP3	126888	63410	1	0.000	A	A	A	A
MP3	126890	63411	1	0.000	A	A	A	A
MP3	126902	63417	1	0.000	A	A	A	A
MP3	126904	63418	1	0.000	A	A	A	A
WAV	121125	60528	2	0.300	A	A	A	A
WAV	121127	60529	2	0.300	A	A	A	A
WAV	122101	61016	2	0.300	A	A	A	A
WAV	125723	62827	2	0.300	A	A	A	A
WAV	125823	62877	2	0.300	A	A	A	A
WAV	125835	62883	2	0.300	A	A	A	A
WAV	125927	62929	2	0.300	A	A	A	A
WAV	125929	62930	2	0.300	A	A	A	A
WAV	125979	62955	2	0.300	A	A	A	A
WAV	126011	62971	2	0.300	A	A	A	A
WAV	126013	62972	2	0.300	A	A	A	A
WAV	126015	62973	2	0.300	A	A	A	A
WAV	126017	62974	2	0.300	A	A	A	A
WAV	126037	62984	2	0.300	A	A	A	A
WAV	126041	62986	2	0.300	A	A	A	A
WAV	126071	63001	2	0.300	A	A	A	A
WAV	126111	63021	2	0.300	A	A	A	A
WAV	126155	63043	2	0.300	A	A	A	A
WAV	126157	63044	2	0.300	A	A	A	A
WAV	126159	63045	2	0.300	A	A	A	A
WAV	126161	63046	2	0.300	A	A	A	A
WAV	126163	63047	2	0.300	A	A	A	A
WAV	126165	63048	2	0.300	A	A	A	A
WAV	126167	63049	2	0.300	A	A	A	A
WAV	126169	63050	2	0.300	A	A	A	A
WAV	126171	63051	2	0.300	A	A	A	A
WAV	126173	63052	2	0.300	A	A	A	A
WAV	126327	63129	2	0.300	A	A	A	A
WAV	126379	63155	2	0.300	A	A	A	A
WAV	126477	63204	2	0.300	A	A	A	A
WAV	126479	63205	2	0.300	A	A	A	A
WAV	126575	63253	2	0.300	A	A	A	A
WAV	126577	63254	2	0.300	A	A	A	A
WAV	126579	63255	2	0.300	A	A	A	A
WAV	126581	63256	2	0.300	A	A	A	A
WAV	126737	63334	2	0.300	A	A	A	A
WAV	126889	63410	2	0.300	A	A	A	A
WAV	126891	63411	2	0.300	A	A	A	A
WAV	126903	63417	2	0.300	A	A	A	A
WAV	126905	63418	2	0.300	A	A	A	A