SELECT col1, col2 FROM table 
    WHERE time > (TIMESTAMP() - (48 * 60 * 60))