UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jr9ZUDZS3A6B670WTjC7R7J7Xfli3ZSJ/vHqpY6lsBM='
WHERE
key_id = '2301956c8880837e8920119bbc1de25d44248fea309396756ae0f39b99bb9759'
AND (
token = 'jr9ZUDZS3A6B670WTjC7R7J7Xfli3ZSJ/vHqpY6lsBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)