SELECT 
  * 
FROM 
  cscart_mb_salvage_cases 
WHERE 
  auction_product_id IN (
    20701, 20702, 20703, 20704, 20705, 20706, 
    20707, 20708, 20709, 20710, 20711, 
    20712, 20713, 20714, 20715, 20716
  ) 
  OR sale_product_id IN (
    20701, 20702, 20703, 20704, 20705, 20706, 
    20707, 20708, 20709, 20710, 20711, 
    20712, 20713, 20714, 20715, 20716
  ) 
ORDER BY 
  updated_at DESC, 
  case_id DESC

Query time 0.00034

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": 56,
          "filtered": 100,
          "attached_condition": "cscart_mb_salvage_cases.auction_product_id in (20701,20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20716) or cscart_mb_salvage_cases.sale_product_id in (20701,20702,20703,20704,20705,20706,20707,20708,20709,20710,20711,20712,20713,20714,20715,20716)"
        }
      }
    }
  }
}