UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sv/vbbWU65OwE/jpKM+kHDVYKpS3Ks/kxMn69Vshzn4='
WHERE
key_id = '617a37ea92ea104c2e3d5e43e77085a4ed75001d0c6ef12cce7d1c71befbb007'
AND (
token = 'sv/vbbWU65OwE/jpKM+kHDVYKpS3Ks/kxMn69Vshzn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)