Adding last seen to devices background update doesn't work

[erikjohnston]

Two issues:

1. The query to fetch the last seen time is wrong, and ends up fetching multiple rows per devices.
2. The query also does a full index scan on postgres as it doesn't understand that the construct a > ? OR (a = ? and b > ?) is equivalent to (a, b) > (?, ?)