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 (
    59025, 59102, 58976, 58356, 59024, 59023, 
    59022, 59021, 59020, 59019, 59018, 
    59017, 59016, 59015, 59014, 59013, 
    59012, 59011, 59010, 59009, 59008, 
    59007, 59006, 59005, 59004, 59003, 
    59002, 59001, 59000, 58999, 58998, 
    58997, 58996, 58995, 58933, 58932, 
    58931, 58930, 58929, 58885
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position, 
  a.variant_id

Query time 0.00125

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	116780	58356	1	0.000	A	A	A	A
MP3	117838	58885	1	0.000	A	A	A	A
MP3	117926	58929	1	0.000	A	A	A	A
MP3	117928	58930	1	0.000	A	A	A	A
MP3	117930	58931	1	0.000	A	A	A	A
MP3	117932	58932	1	0.000	A	A	A	A
MP3	117934	58933	1	0.000	A	A	A	A
MP3	118020	58976	1	0.000	A	A	A	A
MP3	118058	58995	1	0.000	A	A	A	A
MP3	118060	58996	1	0.000	A	A	A	A
MP3	118062	58997	1	0.000	A	A	A	A
MP3	118064	58998	1	0.000	A	A	A	A
MP3	118066	58999	1	0.000	A	A	A	A
MP3	118068	59000	1	0.000	A	A	A	A
MP3	118070	59001	1	0.000	A	A	A	A
MP3	118072	59002	1	0.000	A	A	A	A
MP3	118074	59003	1	0.000	A	A	A	A
MP3	118076	59004	1	0.000	A	A	A	A
MP3	118078	59005	1	0.000	A	A	A	A
MP3	118080	59006	1	0.000	A	A	A	A
MP3	118082	59007	1	0.000	A	A	A	A
MP3	118084	59008	1	0.000	A	A	A	A
MP3	118086	59009	1	0.000	A	A	A	A
MP3	118088	59010	1	0.000	A	A	A	A
MP3	118090	59011	1	0.000	A	A	A	A
MP3	118092	59012	1	0.000	A	A	A	A
MP3	118094	59013	1	0.000	A	A	A	A
MP3	118096	59014	1	0.000	A	A	A	A
MP3	118098	59015	1	0.000	A	A	A	A
MP3	118100	59016	1	0.000	A	A	A	A
MP3	118102	59017	1	0.000	A	A	A	A
MP3	118104	59018	1	0.000	A	A	A	A
MP3	118106	59019	1	0.000	A	A	A	A
MP3	118108	59020	1	0.000	A	A	A	A
MP3	118110	59021	1	0.000	A	A	A	A
MP3	118112	59022	1	0.000	A	A	A	A
MP3	118114	59023	1	0.000	A	A	A	A
MP3	118116	59024	1	0.000	A	A	A	A
MP3	118118	59025	1	0.000	A	A	A	A
MP3	118272	59102	1	0.000	A	A	A	A
WAV	116781	58356	2	0.300	A	A	A	A
WAV	117839	58885	2	0.300	A	A	A	A
WAV	117927	58929	2	0.300	A	A	A	A
WAV	117929	58930	2	0.300	A	A	A	A
WAV	117931	58931	2	0.300	A	A	A	A
WAV	117933	58932	2	0.300	A	A	A	A
WAV	117935	58933	2	0.300	A	A	A	A
WAV	118021	58976	2	0.300	A	A	A	A
WAV	118059	58995	2	0.300	A	A	A	A
WAV	118061	58996	2	0.300	A	A	A	A
WAV	118063	58997	2	0.300	A	A	A	A
WAV	118065	58998	2	0.300	A	A	A	A
WAV	118067	58999	2	0.300	A	A	A	A
WAV	118069	59000	2	0.300	A	A	A	A
WAV	118071	59001	2	0.300	A	A	A	A
WAV	118073	59002	2	0.300	A	A	A	A
WAV	118075	59003	2	0.300	A	A	A	A
WAV	118077	59004	2	0.300	A	A	A	A
WAV	118079	59005	2	0.300	A	A	A	A
WAV	118081	59006	2	0.300	A	A	A	A
WAV	118083	59007	2	0.300	A	A	A	A
WAV	118085	59008	2	0.300	A	A	A	A
WAV	118087	59009	2	0.300	A	A	A	A
WAV	118089	59010	2	0.300	A	A	A	A
WAV	118091	59011	2	0.300	A	A	A	A
WAV	118093	59012	2	0.300	A	A	A	A
WAV	118095	59013	2	0.300	A	A	A	A
WAV	118097	59014	2	0.300	A	A	A	A
WAV	118099	59015	2	0.300	A	A	A	A
WAV	118101	59016	2	0.300	A	A	A	A
WAV	118103	59017	2	0.300	A	A	A	A
WAV	118105	59018	2	0.300	A	A	A	A
WAV	118107	59019	2	0.300	A	A	A	A
WAV	118109	59020	2	0.300	A	A	A	A
WAV	118111	59021	2	0.300	A	A	A	A
WAV	118113	59022	2	0.300	A	A	A	A
WAV	118115	59023	2	0.300	A	A	A	A
WAV	118117	59024	2	0.300	A	A	A	A
WAV	118119	59025	2	0.300	A	A	A	A
WAV	118273	59102	2	0.300	A	A	A	A