UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8FJVd8p1PqMt3VD88kMT7gqIuh4mfdXc2kij8ShzpE='
WHERE
key_id = '528d3fd6ff221179142f4b8478a8c3d8c33af134f7f6046de4cd91e369b44489'
AND (
token = 'q8FJVd8p1PqMt3VD88kMT7gqIuh4mfdXc2kij8ShzpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)