UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+JuJSZz9HJJ8aMiqlIh6NZARdBzfwgnv5c+iq2cL2eU='
WHERE
key_id = 'a0d943960c8d51c0abab7851d7b7a5320733f2a8e047a987b5e36bc87eaca4cf'
AND (
token = '+JuJSZz9HJJ8aMiqlIh6NZARdBzfwgnv5c+iq2cL2eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)