UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Bh+BwZIrgKOX2xj3tVSSDq24PYAbNS5flsZeBs7uVg='
WHERE
key_id = 'a15e2ea2d39cc8b3f272dedcab5dc070e4dfcf176b8a6ede9707e888024e5f6a'
AND (
token = '6Bh+BwZIrgKOX2xj3tVSSDq24PYAbNS5flsZeBs7uVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)