my $sqla = SQL::Abstract::More->new;

my $time   = time;
my $status = 'active';

my ( $sql, @bind ) = $sqla->select( # new users yesterday
    -columns => 'id, name',
    -from    => 'users',
    -where   => {
        status          => $status,
        first_seen_time => {
            '>'  => $time - 86400,
            '<=' => $time,
        },
    },
);

##</code><code>##

$sql: 'SELECT id, name FROM users WHERE ( ( ( first_seen_time <= ? AND first_seen_time > ? ) AND status = ? ) )';

\@bind: [
          1492373509,
          1492287109,
          'active'
        ];