db_update('block')
    ->fields([
      'weight' => 0,
    ])
    ->expression('status', "(theme = 'theme_carrefour')")
    ->expression('region', "CASE WHEN theme = 'theme_carrefour' THEN 'header' ELSE '-1' END")
    ->condition('module', 'recherche_carrefour', '=')
    ->condition('delta', 'recherche_textuelle', '=')
    ->execute();