UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Ht4BJvQbDdxhttyvP4X7vqnJ41hA30VmVwjOiEzx80='
WHERE
key_id = '1cd09470b9453e2f003282e9cdbde984f29aa14ed16012d9c61f4d4cf5fb53fe'
AND (
token = '5Ht4BJvQbDdxhttyvP4X7vqnJ41hA30VmVwjOiEzx80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)