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 (
    62954, 60863, 60771, 60770, 62931, 60910, 
    62921, 62920, 62919, 62905, 62882, 
    62810, 60691, 60548, 60526, 59708, 
    60827, 60434, 61060, 61106, 61057, 
    60500, 60499, 60407, 55710, 61002, 
    61001, 60971, 60970, 60969, 60968, 
    60967, 60966, 60965, 60964, 60963, 
    60962, 60961, 60960, 60959
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00147

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	111486	55710	1	0.000	A	A	A	A
MP3	119484	59708	1	0.000	A	A	A	A
MP3	120882	60407	1	0.000	A	A	A	A
MP3	120936	60434	1	0.000	A	A	A	A
MP3	121066	60499	1	0.000	A	A	A	A
MP3	121068	60500	1	0.000	A	A	A	A
MP3	121120	60526	1	0.000	A	A	A	A
MP3	121164	60548	1	0.000	A	A	A	A
MP3	121450	60691	1	0.000	A	A	A	A
MP3	121608	60770	1	0.000	A	A	A	A
MP3	121610	60771	1	0.000	A	A	A	A
MP3	121722	60827	1	0.000	A	A	A	A
MP3	121794	60863	1	0.000	A	A	A	A
MP3	121888	60910	1	0.000	A	A	A	A
MP3	121986	60959	1	0.000	A	A	A	A
MP3	121988	60960	1	0.000	A	A	A	A
MP3	121990	60961	1	0.000	A	A	A	A
MP3	121992	60962	1	0.000	A	A	A	A
MP3	121994	60963	1	0.000	A	A	A	A
MP3	121996	60964	1	0.000	A	A	A	A
MP3	121998	60965	1	0.000	A	A	A	A
MP3	122000	60966	1	0.000	A	A	A	A
MP3	122002	60967	1	0.000	A	A	A	A
MP3	122004	60968	1	0.000	A	A	A	A
MP3	122006	60969	1	0.000	A	A	A	A
MP3	122008	60970	1	0.000	A	A	A	A
MP3	122010	60971	1	0.000	A	A	A	A
MP3	122070	61001	1	0.000	A	A	A	A
MP3	122072	61002	1	0.000	A	A	A	A
MP3	122182	61057	1	0.000	A	A	A	A
MP3	122188	61060	1	0.000	A	A	A	A
MP3	122280	61106	1	0.000	A	A	A	A
MP3	125688	62810	1	0.000	A	A	A	A
MP3	125832	62882	1	0.000	A	A	A	A
MP3	125878	62905	1	0.000	A	A	A	A
MP3	125906	62919	1	0.000	A	A	A	A
MP3	125908	62920	1	0.000	A	A	A	A
MP3	125910	62921	1	0.000	A	A	A	A
MP3	125930	62931	1	0.000	A	A	A	A
MP3	125976	62954	1	0.000	A	A	A	A
WAV	111487	55710	2	0.300	A	A	A	A
WAV	119485	59708	2	0.300	A	A	A	A
WAV	120883	60407	2	0.300	A	A	A	A
WAV	120937	60434	2	0.300	A	A	A	A
WAV	121067	60499	2	0.300	A	A	A	A
WAV	121069	60500	2	0.300	A	A	A	A
WAV	121121	60526	2	0.300	A	A	A	A
WAV	121165	60548	2	0.300	A	A	A	A
WAV	121451	60691	2	0.300	A	A	A	A
WAV	121609	60770	2	0.300	A	A	A	A
WAV	121611	60771	2	0.300	A	A	A	A
WAV	121723	60827	2	0.300	A	A	A	A
WAV	121795	60863	2	0.300	A	A	A	A
WAV	121889	60910	2	0.300	A	A	A	A
WAV	121987	60959	2	0.300	A	A	A	A
WAV	121989	60960	2	0.300	A	A	A	A
WAV	121991	60961	2	0.300	A	A	A	A
WAV	121993	60962	2	0.300	A	A	A	A
WAV	121995	60963	2	0.300	A	A	A	A
WAV	121997	60964	2	0.300	A	A	A	A
WAV	121999	60965	2	0.300	A	A	A	A
WAV	122001	60966	2	0.300	A	A	A	A
WAV	122003	60967	2	0.300	A	A	A	A
WAV	122005	60968	2	0.300	A	A	A	A
WAV	122007	60969	2	0.300	A	A	A	A
WAV	122009	60970	2	0.300	A	A	A	A
WAV	122011	60971	2	0.300	A	A	A	A
WAV	122071	61001	2	0.300	A	A	A	A
WAV	122073	61002	2	0.300	A	A	A	A
WAV	122183	61057	2	0.300	A	A	A	A
WAV	122189	61060	2	0.300	A	A	A	A
WAV	122281	61106	2	0.300	A	A	A	A
WAV	125689	62810	2	0.300	A	A	A	A
WAV	125833	62882	2	0.300	A	A	A	A
WAV	125879	62905	2	0.300	A	A	A	A
WAV	125907	62919	2	0.300	A	A	A	A
WAV	125909	62920	2	0.300	A	A	A	A
WAV	125911	62921	2	0.300	A	A	A	A
WAV	125931	62931	2	0.300	A	A	A	A
WAV	125977	62954	2	0.300	A	A	A	A