UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V5pZWM8ECxKKfo2SrQ+7oj9A6l2p8h0AZLr+VC0pnxo='
WHERE
key_id = '7991fba07245c2148a7c3be202f6fa2a3d0c8212b3e75fccf77aa3efd661c34e'
AND (
token = 'V5pZWM8ECxKKfo2SrQ+7oj9A6l2p8h0AZLr+VC0pnxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)