UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/56afFv3saeLVmk9RiyZZ8bPR8DZs9DMA4YY4O2L4O0='
WHERE
key_id = '387bdf8c9ff8a23ff660b5a8fca754bf345ef33b536f4ca4997894ab451575e1'
AND (
token = '/56afFv3saeLVmk9RiyZZ8bPR8DZs9DMA4YY4O2L4O0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)