UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'obpx+VP6R8PuRsdpHKcArgOv9tAnkuGI74eX+AgyEQM='
WHERE
key_id = 'b49fbc2c196af83da5802cb5a8ad7e17b0884c05f854d214176f2058280dc815'
AND (
token = 'obpx+VP6R8PuRsdpHKcArgOv9tAnkuGI74eX+AgyEQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)