UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1k0+GpRU7llXfZFc3I56SBNMAzqL3YEa5MepcA/Bik='
WHERE
key_id = '381756d967e0265da04d871b4c39adec4629192d454515aca728a751bbf4f00e'
AND (
token = 'L1k0+GpRU7llXfZFc3I56SBNMAzqL3YEa5MepcA/Bik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)