UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jRsV1wFmg4+jKg7R8DC6uKG/+LxblFA6bS/i5VCnGqk='
WHERE
key_id = '3272f09d5783a982d381f3d02590d8a089755ce46cebcf6b8beb5f3a19f78d77'
AND (
token = 'jRsV1wFmg4+jKg7R8DC6uKG/+LxblFA6bS/i5VCnGqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)