select * from table \ where (column1 = 'val11' and column2 = 'val12') \ or (column1 = 'val21' and column2 = 'val22')こんな感じで記述。
$result = Model_Table::query() ->and_where_open() ->where('column1', '=', 'var11') ->where('column2', '=', 'val12') ->and_where_close() ->or_where_open() ->where('column1', '=', 'var21') ->where('column02', '=', 'val22') ->or_where_close();