UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xj415ggzGmNC5AdY1yh+3nX5j1S28pEbgBQBMMI/Rg0='
WHERE
key_id = '713a82055c7dea46a634d2f1fed0c6145a614d58d55a97aa33f16947743ce387'
AND (
token = 'Xj415ggzGmNC5AdY1yh+3nX5j1S28pEbgBQBMMI/Rg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)