DELETE fcf, 
fcfp 
FROM 
  cscart_csc_full_page_cache_files fcf 
  LEFT JOIN cscart_csc_full_page_cache_files_products fcfp ON fcf.file_id = fcfp.file_id 
WHERE 
  file_hash = '1e40bb3d83b4'