UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y2rqptr744HkOi3A2XS2A7pl85x5yTfYHI5IDiPhqOU='
WHERE
key_id = '3feb3bca8d20fa9b47cb2d9d335151f9614f5f1570969b858571dfb1ad00a97c'
AND (
token = 'y2rqptr744HkOi3A2XS2A7pl85x5yTfYHI5IDiPhqOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)