UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nE3+Q8jST348qyol1a2NKp5tHqe2qYAwEDgxT94Y7nM='
WHERE
key_id = 'c87f6ee65cfd79cd97c25261639d0c614e747a6d386c53ee19235ab95717ad49'
AND (
token = 'nE3+Q8jST348qyol1a2NKp5tHqe2qYAwEDgxT94Y7nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)