UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kP8C1+lz32s/QwMDk9IR3Sg8a/ALs5LrpiyYbMteAg0='
WHERE
key_id = 'cbb266b22321ce751b0735c7962818fd228d887302d6f2d5943d9675ca0bd611'
AND (
token = 'kP8C1+lz32s/QwMDk9IR3Sg8a/ALs5LrpiyYbMteAg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)