SELECT 
  * 
FROM 
  cscart_mb_salvage_cases 
WHERE 
  auction_product_id IN (
    24569, 24570, 24571, 24572, 24573, 24574, 
    24575, 24576, 24577, 24578, 24579, 
    24580, 24581, 24582, 24583, 24584
  ) 
  OR sale_product_id IN (
    24569, 24570, 24571, 24572, 24573, 24574, 
    24575, 24576, 24577, 24578, 24579, 
    24580, 24581, 24582, 24583, 24584
  ) 
ORDER BY 
  updated_at DESC, 
  case_id DESC

Query time 0.00032

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_mb_salvage_cases.updated_at desc, cscart_mb_salvage_cases.case_id desc",
        "table": {
          "table_name": "cscart_mb_salvage_cases",
          "access_type": "ALL",
          "rows": 58,
          "filtered": 100,
          "attached_condition": "cscart_mb_salvage_cases.auction_product_id in (24569,24570,24571,24572,24573,24574,24575,24576,24577,24578,24579,24580,24581,24582,24583,24584) or cscart_mb_salvage_cases.sale_product_id in (24569,24570,24571,24572,24573,24574,24575,24576,24577,24578,24579,24580,24581,24582,24583,24584)"
        }
      }
    }
  }
}