my $sql = <<SQL;
    select name, year
    from mytable
    where acc = 12345
      and (year =? or year =?+1)
SQL;
my $sth_year = $dbh->prepare($sql);
$sth_year->execute( $year );
my $results = $sth_year->fetchall_arrayref();
...