SELECT 
  l.* 
FROM 
  cscart_label_manager_labels l 
WHERE 
  l.label_id = 10000002 
  AND l.status = 'A'

Query time 0.00022

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE l const PRIMARY,status PRIMARY 3 const 1

Result

label_id name status contact_name email alt_contact_name alt_email facebook twitter soundcloud youtube motd_slug writer_split split_condition toolboxCheck aggregator created_at updated_at lang_code
10000002 Tidy A aggregator generated label label@labelworx.com aggregator generated label label@labelworx.com https://www.facebook.com/tidyofficial https://twitter.com/TidyOfficial https://soundcloud.com/tidyofficial https://www.youtube.com/TidyTV # 0.00 percent 0 labelworx 1644221610 EN