UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1edLLCreXR+Vy9T1P57kBt9IHSBC0GPhjI/qSZqXqro='
WHERE
key_id = '07c08d3692de94bd776661e4d6d1d3a3a9b715440f98fa571682f65e41969600'
AND (
token = '1edLLCreXR+Vy9T1P57kBt9IHSBC0GPhjI/qSZqXqro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)