UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qANT895ODmNUVTsGOY5UQrkX6LHgbuMFckXKTp6IYzU='
WHERE
key_id = '7150e077eba871c31e1f88c24958404c7a5a5010bc3c33de4905abef68b33fe9'
AND (
token = 'qANT895ODmNUVTsGOY5UQrkX6LHgbuMFckXKTp6IYzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)